Flashback Queries

Working with the Oracle Flashback option we can restore the old data using flashback queries. Introduced in Oracle Version 9.2 the “AS OF” clause can be used to: find the old data restore the old data Mistakenly set the salary of Manager King to a wrong value: SQL> update emp set sal=4500 where ename=’KING’; 1 … Continue reading Flashback Queries